Data Source Schema View

The Data Source schema view shows tables, views and stored procedures of a particular data source. It provides a list-based visual representation of the content of the schema.

Tables / Views

• Click on a table in the tables list to show its columns in the pane below. Views also have their SQL definition displayed in the lower pane.
• Right-click on a table or view in the list to view its content, create a virtual view, find the corresponding replication jobs or optimizations, manage permissions and trigger statistics gathering, among other options. Virtual views also offer the option to edit their definition on the SQL editor.

Stored Procedures

• Double-click on a stored procedure in a procedures list to generate corresponding procedure call in sql editor.
• Click on a stored procedure in a procedures list to show its input and output parameters in the pane below, as well as its definition.
• Right-click on a procedure in a procedures list to edit, drop, set a description or manage permissions for said procedure.

See also:

• Virtual Views
• Analytical Storage view